home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 1998 September
/
CHIP Eylül 1998.iso
/
demolar
/
lokman
/
DISK1
/
_SETUP.2
/
Group1
/
Tarihdll.dll
/
0
/
RCDATA
/
TBRSTOKFORM
/
TBRSTOKFORM.txt
Wrap
Text File
|
1998-07-24
|
18KB
|
642 lines
object BrStokForm: TBrStokForm
Left = 24
Top = 72
Width = 559
Height = 316
ActiveControl = DBGrid1
Caption = '�R�N G�R�� �IKI� HAREKETLER�'
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'System'
Font.Style = []
KeyPreview = True
OnClose = FormClose
OnCreate = FormCreate
OnShow = FormShow
PixelsPerInch = 96
TextHeight = 16
object Panel1: TPanel
Left = 0
Top = 0
Width = 551
Height = 289
HelpContext = 518
Align = alClient
BevelInner = bvLowered
BevelWidth = 2
Caption = 'Panel1'
Color = clGray
TabOrder = 0
object ScrollBox1: TScrollBox
Left = 4
Top = 4
Width = 543
Height = 281
Align = alClient
AutoScroll = False
TabOrder = 0
object LabelAD: TLabel
Left = 8
Top = 3
Width = 55
Height = 14
Caption = 'Hangi Ila�'
Font.Color = clWhite
Font.Height = -12
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentFont = False
end
object DBText1: TDBText
Left = 314
Top = 186
Width = 109
Height = 17
Alignment = taRightJustify
Color = clNavy
DataField = 'SUM OF CIKMIK * CIKFIYAT'
DataSource = DataSource1
Font.Color = clWhite
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentColor = False
ParentFont = False
end
object DBText2: TDBText
Left = 267
Top = 186
Width = 45
Height = 17
Alignment = taRightJustify
Color = clNavy
DataField = 'SUM OF CIKMIK'
DataSource = DataSource1
Font.Color = clWhite
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentColor = False
ParentFont = False
end
object DBText3: TDBText
Left = 140
Top = 186
Width = 125
Height = 17
Alignment = taRightJustify
Color = clWhite
DataField = 'SUM OF GIRMIK * GIRFIYAT'
DataSource = DataSource1
Font.Color = clNavy
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentColor = False
ParentFont = False
end
object DBText4: TDBText
Left = 90
Top = 186
Width = 48
Height = 17
Alignment = taRightJustify
Color = clWhite
DataField = 'SUM OF GIRMIK'
DataSource = DataSource1
Font.Color = clNavy
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentColor = False
ParentFont = False
end
object Label1: TLabel
Left = 45
Top = 186
Width = 42
Height = 15
Caption = 'Toplam'
Font.Color = clWhite
Font.Height = -12
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentFont = False
end
object Label3: TLabel
Left = 4
Top = 245
Width = 55
Height = 29
Caption = 'Yaz�c� Sol Marj (cm)'
Font.Color = clWhite
Font.Height = -11
Font.Name = 'Arial Tur'
Font.Style = [fsBold]
ParentFont = False
WordWrap = True
end
object DBText5: TDBText
Left = 424
Top = 186
Width = 113
Height = 16
Alignment = taRightJustify
Color = clRed
DataField = 'FARK'
DataSource = DataSource1
Font.Color = clWhite
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentColor = False
ParentFont = False
end
object Label2: TLabel
Left = 376
Top = 3
Width = 110
Height = 14
Caption = 'Hareket D��� Miktar :'
Font.Color = clBlack
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentFont = False
end
object DBText6: TDBText
Left = 490
Top = 1
Width = 46
Height = 17
Color = clNavy
DataField = 'SUM OF MIKDEG'
DataSource = DataSource2
Font.Color = clWhite
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentColor = False
ParentFont = False
end
object Label4: TLabel
Left = 425
Top = 173
Width = 21
Height = 14
Caption = 'Fark'
Font.Color = clWhite
Font.Height = -11
Font.Name = 'Arial'
Font.Style = []
ParentFont = False
Transparent = True
end
object DBGrid1: TDBGrid
Left = 0
Top = 19
Width = 538
Height = 156
Color = clNavy
DataSource = UrunHarSRC
Font.Color = clWhite
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
ParentFont = False
ReadOnly = True
TabOrder = 0
TitleFont.Color = clNavy
TitleFont.Height = -11
TitleFont.Name = 'Arial'
TitleFont.Style = [fsBold]
OnKeyUp = DBGrid1KeyUp
end
object BitBtnTAM: TBitBtn
Left = 459
Top = 248
Width = 75
Height = 25
Font.Color = clNavy
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentFont = False
TabOrder = 8
Kind = bkOK
end
object BitBtnTARIH: TBitBtn
Left = 357
Top = 248
Width = 95
Height = 25
Caption = 'Tarih Aral��� '
Font.Color = clNavy
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentFont = False
TabOrder = 7
OnClick = BitBtnTARIHClick
Glyph.Data = {
78010000424D7801000000000000760000002800000020000000100000000100
04000000000000000000120B0000120B00000000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
33333FFFFFFFFFFFFFFF000000000000000077777777777777770FF7FF7FF7FF
7FF07FF7FF7FF7F37F3709F79F79F7FF7FF077F77F77F7FF7FF7077777777777
777077777777777777770FF7FF7FF7FF7FF07FF7FF7FF7FF7FF709F79F79F79F
79F077F77F77F77F77F7077777777777777077777777777777770FF7FF7FF7FF
7FF07FF7FF7FF7FF7FF709F79F79F79F79F077F77F77F77F77F7077777777777
777077777777777777770FFFFF7FF7FF7FF07F33337FF7FF7FF70FFFFF79F79F
79F07FFFFF77F77F77F700000000000000007777777777777777CCCCCC8888CC
CCCC777777FFFF777777CCCCCCCCCCCCCCCC77777777777777770000}
NumGlyphs = 2
end
object Edit1: TEdit
Left = 4
Top = 208
Width = 59
Height = 23
Color = clNavy
Enabled = False
Font.Color = clWhite
Font.Height = -12
Font.Name = 'Arial'
Font.Style = [fsBold, fsUnderline]
ParentFont = False
TabOrder = 1
Text = 'A��klama'
end
object Panel2: TPanel
Left = 65
Top = 207
Width = 468
Height = 33
BevelOuter = bvLowered
Caption = 'Panel2'
TabOrder = 2
object EditACIK: TLabel
Left = 1
Top = 1
Width = 466
Height = 31
Align = alClient
Caption = 'EditACIK'
Color = clSilver
Font.Color = clBlack
Font.Height = -12
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentColor = False
ParentFont = False
end
end
object AylikBtn: TBitBtn
Left = 254
Top = 248
Width = 95
Height = 25
HelpContext = 519
Caption = '&Ayl�k Rapor'
Font.Color = clNavy
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentFont = False
TabOrder = 6
OnClick = AylikBtnClick
Glyph.Data = {
78010000424D7801000000000000760000002800000020000000100000000100
04000000000000000000120B0000120B00000000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333330000000
00003333377777777777333330FFFFFFFFF03FF3F7FFFF33FFF7003000000FF0
00F077F7777773F77737E00FBFBFB0FFFFF07773333FF7FF33F7E0FBFB00000F
F0F077F333777773F737E0BFBFBFBFB0FFF077F3333FFFF733F7E0FBFB00000F
F0F077F333777773F737E0BFBFBFBFB0FFF077F33FFFFFF733F7E0FB0000000F
F0F077FF777777733737000FB0FFFFFFFFF07773F7F333333337333000FFFFFF
FFF0333777F3FFF33FF7333330F000FF0000333337F777337777333330FFFFFF
0FF0333337FFFFFF7F37333330CCCCCC0F033333377777777F73333330FFFFFF
0033333337FFFFFF7733333330000000033333333777777773330000}
NumGlyphs = 2
end
object BitBtn1: TBitBtn
Left = 183
Top = 248
Width = 65
Height = 25
HelpContext = 519
Caption = '&Yazd�r'
Font.Color = clNavy
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentFont = False
TabOrder = 5
OnClick = BitBtn1Click
Glyph.Data = {
78010000424D7801000000000000760000002800000020000000100000000100
04000000000000000000120B0000120B00000000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333330000000
00003333377777777777333330FFFFFFFFF03FF3F7FFFF33FFF7003000000FF0
00F077F7777773F77737E00FBFBFB0FFFFF07773333FF7FF33F7E0FBFB00000F
F0F077F333777773F737E0BFBFBFBFB0FFF077F3333FFFF733F7E0FBFB00000F
F0F077F333777773F737E0BFBFBFBFB0FFF077F33FFFFFF733F7E0FB0000000F
F0F077FF777777733737000FB0FFFFFFFFF07773F7F333333337333000FFFFFF
FFF0333777F3FFF33FF7333330F000FF0000333337F777337777333330FFFFFF
0FF0333337FFFFFF7F37333330CCCCCC0F033333377777777F73333330FFFFFF
0033333337FFFFFF7733333330000000033333333777777773330000}
NumGlyphs = 2
end
object SpinEdit1: TSpinEdit
Left = 59
Top = 247
Width = 44
Height = 24
Font.Color = clBlack
Font.Height = -12
Font.Name = 'Arial'
Font.Style = [fsBold]
MaxLength = 25
MaxValue = 0
MinValue = 0
ParentFont = False
TabOrder = 3
Value = 0
end
object BtnYF: TBitBtn
Left = 110
Top = 248
Width = 67
Height = 25
Caption = '&Fontu'
Font.Color = clNavy
Font.Height = -11
Font.Name = 'Arial'
Font.Style = [fsBold]
ParentFont = False
TabOrder = 4
OnClick = BtnYFClick
Glyph.Data = {
76010000424D7601000000000000760000002800000020000000100000000100
04000000000000010000130B0000130B00000000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
3333333333333333333333333333333333333FF3FFFFFFF33FFF003000000033
0000773777777733777703330033033330037FFF77F37F33377F700007330333
3003777777337FFFF77F303003337000007337F77F3377777773303073333033
003337F77F3337F377F337007333303300333777733337FF77F3330033333703
07333377F333377F7733330733333300033333773FF3F3777F33333399393300
033333337737FF777F333333339993307333333333777FF77333333333999930
3333333333777737333333333333333333333333333333333333333333333333
3333333333333333333333333333333333333333333333333333}
NumGlyphs = 2
end
end
end
object UrunHarTab: TTable
AfterOpen = UrunHarTabAfterOpen
BeforeClose = UrunHarTabBeforeClose
DatabaseName = 'ECZ'
IndexFieldNames = 'ILACNO;GCTARIH;ALSATNO'
TableName = 'URUNHRK.DB'
Left = 232
Top = 8
object UrunHarTabILACNO: TIntegerField
FieldName = 'ILACNO'
Visible = False
end
object UrunHarTabGCTARIH: TDateTimeField
DisplayLabel = 'Tarih'
DisplayWidth = 12
FieldName = 'GCTARIH'
DisplayFormat = 'dd.mm.yy hh:nn'
end
object UrunHarTabGIRMIK: TIntegerField
DisplayLabel = 'Gr�.Mik.'
DisplayWidth = 7
FieldName = 'GIRMIK'
end
object UrunHarTabGIRFIYAT: TCurrencyField
DisplayLabel = 'Giri� Fiyat�'
DisplayWidth = 20
FieldName = 'GIRFIYAT'
DisplayFormat = '#,#'
end
object UrunHarTabCIKMIK: TIntegerField
DisplayLabel = '��k.Mik.'
DisplayWidth = 7
FieldName = 'CIKMIK'
end
object UrunHarTabCIKFIYAT: TCurrencyField
DisplayLabel = '��k�� Fiyat�'
DisplayWidth = 17
FieldName = 'CIKFIYAT'
DisplayFormat = '#,#'
end
object UrunHarTabALSATNO: TFloatField
DisplayLabel = 'Hareket No'
DisplayWidth = 15
FieldName = 'ALSATNO'
OnGetText = UrunHarTabALSATNOGetText
end
object UrunHarTabSIRANO: TIntegerField
FieldName = 'SIRANO'
Visible = False
end
end
object UrunHarSRC: TDataSource
DataSet = UrunHarTab
OnDataChange = UrunHarSRCDataChange
Left = 192
end
object recStokTAB: TTable
DatabaseName = 'ECZ'
IndexFieldNames = 'SATISNO'
MasterFields = 'ALSATNO'
MasterSource = UrunHarSRC
TableName = 'RECETE.DB'
Left = 360
Top = 144
object recStokTABSATISNO: TFloatField
FieldName = 'SATISNO'
end
object recStokTABKURUMKOD: TStringField
FieldName = 'KURUMKOD'
Size = 11
end
object recStokTABHASTANO: TIntegerField
FieldName = 'HASTANO'
end
end
object FatStokTAB: TTable
DatabaseName = 'ECZ'
IndexFieldNames = 'SATISNO'
MasterFields = 'ALSATNO'
MasterSource = UrunHarSRC
TableName = 'FATURA.DB'
Left = 296
Top = 144
object FatStokTABSATISNO: TFloatField
FieldName = 'SATISNO'
end
object FatStokTABKRMAD: TStringField
FieldName = 'KRMAD'
Size = 36
end
end
object HastaSTAB: TTable
AutoCalcFields = False
DatabaseName = 'ECZ'
TableName = 'HASTA.DB'
Left = 336
Top = 144
object HastaSTABHASTANO: TIntegerField
FieldName = 'HASTANO'
end
object HastaSTABHASTADI: TStringField
FieldName = 'HASTADI'
Size = 18
end
object HastaSTABHASTASOYAD: TStringField
FieldName = 'HASTASOYAD'
Size = 18
end
end
object AliStkTAB: TTable
DatabaseName = 'ECZ'
IndexFieldNames = 'ALISNO'
TableName = 'ALIS1.DB'
Left = 176
Top = 144
object AliStkTABKRMKOD: TStringField
FieldName = 'KRMKOD'
Size = 11
end
object AliStkTABALISNO: TFloatField
FieldName = 'ALISNO'
end
object AliStkTABFATNO: TStringField
FieldName = 'FATNO'
Size = 15
end
end
object SatSTKTAB: TTable
DatabaseName = 'ECZ'
TableName = 'SATIS.DB'
Left = 336
Top = 104
object SatSTKTABSATISNO: TFloatField
FieldName = 'SATISNO'
end
object SatSTKTABPARAKENDE: TStringField
FieldName = 'PARAKENDE'
Size = 1
end
end
object QTOP: TQuery
OnCalcFields = QTOPCalcFields
DatabaseName = 'ECZ'
Params.Data = {0100010004696C6E6F00030400010000000001}
SQL.Strings = (
'SELECT'
'SUM(GIRMIK* GIRFIYAT),'
'SUM(CIKMIK*CIKFIYAT),'
'SUM(GIRMIK),'
'SUM(CIKMIK)'
'FROM'
'URUNHRK'
'WHERE ILACNO=:ilno')
Left = 214
Top = 142
object QTOPSUMOFGIRMIKGIRFIYAT: TCurrencyField
FieldName = 'SUM OF GIRMIK * GIRFIYAT'
DisplayFormat = '#,#'
end
object QTOPSUMOFCIKMIKCIKFIYAT: TCurrencyField
FieldName = 'SUM OF CIKMIK * CIKFIYAT'
DisplayFormat = '#,#'
end
object QTOPSUMOFGIRMIK: TFloatField
FieldName = 'SUM OF GIRMIK'
end
object QTOPSUMOFCIKMIK: TFloatField
FieldName = 'SUM OF CIKMIK'
end
object QTOPFARK: TCurrencyField
Calculated = True
FieldName = 'FARK'
end
end
object DataSource1: TDataSource
DataSet = QTOP
Left = 238
Top = 150
end
object PrintDialog1: TPrintDialog
Left = 367
Top = 215
end
object FontDialog1: TFontDialog
Font.Color = clBlack
Font.Height = -11
Font.Name = 'Courier New'
Font.Style = []
Device = fdBoth
MinFontSize = 0
MaxFontSize = 0
Options = [fdAnsiOnly, fdEffects, fdFixedPitchOnly]
Left = 16
Top = 168
end
object FontTab: TTable
DatabaseName = 'ECZ'
TableName = 'FONT.DB'
Left = 104
Top = 192
object FontTabBIRIM: TStringField
FieldName = 'BIRIM'
Size = 9
end
object FontTabFONTADI: TStringField
FieldName = 'FONTADI'
Size = 35
end
object FontTabFONTSIZE: TSmallintField
FieldName = 'FONTSIZE'
end
object FontTabCOLOR: TIntegerField
FieldName = 'COLOR'
end
object FontTabSTYLE: TStringField
FieldName = 'STYLE'
Size = 1
end
object FontTabMARJIN: TSmallintField
FieldName = 'MARJIN'
end
end
object DataSource2: TDataSource
DataSet = Query1
Left = 390
Top = 54
end
object Query1: TQuery
DatabaseName = 'ECZ'
DataSource = UrunHarSRC
Params.Data = {0100010006494C41434E4F00030400701700000000}
SQL.Strings = (
'SELECT '
'ILACNO,'
'SUM(MIKDEG)'
'FROM MRAPORD'
'WHERE MRAPORD.ILACNO=:ILACNO'
'GROUP BY MRAPORD.ILACNO')
Left = 422
Top = 102
end
end